USE AdventureWorks2008
GO
CREATE TABLE Sales.SalesTerritoryOrg
(OrgNode hierarchyid PRIMARY KEY CLUSTERED,
OrgLevel AS OrgNode.GetLevel(),
TerritoryID int UNIQUE NOT NULL,
TerritoryName varchar(50) NOT NULL
);
GO